Dataform
An overview of the Dataform integration with Secoda
Last updated
Was this helpful?
An overview of the Dataform integration with Secoda
Last updated
Was this helpful?
There are three steps to connect Dataform with Secoda:
Enable Dataform API
Create a service account for Secoda
Connect Dataform to Secoda
Go to Google Cloud Console and login.
Make sure you’re working in the project where you want to connect Dataform to Secoda.
Navigate to the APIs & Services page:
In the left-hand menu, go to APIs & Services > Dashboard.
Go to Enable APIs & Services at the top and search for Dataform
Navigate back to APIs & Services page:
In the list of APIs, check if “Dataform API” appears. If it’s listed and says Enabled, it’s active
From the Navigation panel on the left, go to IAM & admin > Service accounts
Click Create Service Account along the top
Enter a name (for example: “secoda”) and click Create
When assigning permissions, make sure to grant the following permissions:
a) If you're creating the service account via the GCP console add the following roles:
b) If you're programatically creating the service account add the following roles:
From the Navigation panel on the left go Integrations > Add new integration
Select Dataform
Enter in the project name and project location and paste the JSON key file contents that was downloaded
Click "Connect"
To provide to Secoda for extracting Big Query metadata, you can create a new service account following the steps below. Refer to for more information.
5. . The downloaded file will be used to create your warehouse in the next section.
Log into your Secoda profile at