0) Install ISQL If you’re on macOS the easiest way to install isql is using homebrew brew install unixodbc. 1) Download drivers Download ODBC Package & Basic Package from here Create an oracle account if necessary 2) Prepare driver files cd Downloads unzip instantclient-basic-macos.x64-22.214.171.124.0dbru.zip unsip instantclient-odbc-macos.x64-126.96.36.199.0dbru.zip mkdir ~/lib mkdir -p /opt/oracle/ mv $(pwd)/instantclient_19_3 /opt/oracle/ ln -s /opt/oracle/instantclient_19_3/libclntsh.dylib.19.1 /opt/oracle/instantclient_19_3/libclntshcore.dylib.19.1 ~/lib 3) Update ODBC ini files update odbcinst.
0) Install DBeaver You can find installation instructions here. Make sure to install version 5.2.2 or later. If you haven’t updated to 5.2.2 or later you may use this post as a guide for connecting to BigQuery. 1) Create a new service account Instructions & details for creating a new service account can be found on Google’s website Grant your desired BigQuery permissions to your new service account Download the service account key 2) Create a new connection In the menu bar navigate to Database > New Connection Select BigQuery & press next Fill in project with the name of your BigQuery Project Optional, add additional projects in the subsequent field Select service-based Fill in the name of the service account ex: bigquery-demo@project_name.
r-richmond is an analytically minded individual who is currently pursuing data analytics at a large tech company. His expertise lies in SQL, data engineering, data visualizations & misc programming. His experience ranges from submitting pull requests for open sourced tools to recommending new business strategies.
BSc in Civil Engineering