Creating service account
A Google Cloud Platform service account is required to connect BigQuery with Lyftrondata. To create service account go to “IAM and Admin” and click “Service Accounts”.
Then at the top is "+ create service account"
In the view that opens enter the name, Id and optional description. Click “Create”
Creating service account keys
To generate service keys in p12 and json format, click "+ create key" in the detailed view of the service account. Select the type of key and click "create". The file download should start automatically. Then repeat the procedure for the second type of key. As a result, you have two files that are service keys. When generating the key, you can set a key password. The default password is "notasecret".
Creating a new GogleBigquery connection in Lyftrondata
Follow the below steps and the Video for a better understanding of how to create Bigquery connection with a Service account and load data into the database.
Step1: From the Lyftrondata menu, select "CONNECT" and click "ADD CONNECTION" in the upper right corner.
Step2: Select “Google BigQuery” from the available providers. You can use a filter for easier searching
Step3: Then complete the fields for connection details. After clicking "Choose File", select from the disk the key files that you downloaded from the Google Cloud Platform.
Step4: Before creating the connection, test it by clicking "Test Connection" at the bottom. The green information in the upper right corner means that the connection is properly configured. Click "Create" to complete the connection
Step5: Add Target -> Create Pipeline -> Choose the Source table to load into Bigquery ->Load the data.