BigQuery (Google Cloud) Quick-Start Guide
Start sending Confection data to BigQuery (Google Cloud) with a few simple steps.
Click “My Account” (or “Set Up My Account” if you’re accessing your account for the first time). Enter your contact information, the domain(s) on which you want to use Confection, and select one of our two data storage options. Then, click “Save Changes.”
Click "Install Confection" (If you're accessing your account for the first time, this will be the default screen.) Select your preferred langauge, CMS, platform, or framework to download the relevant scripts.
At this point, use the relevant language, framework, CMS, or platform quick start guide to get Confection up and running on your site or app. Then, continue with step four.
By default, Confection stores data for 24 hours. During that timeframe, it’s available in your account to query and send anywhere via your account API, one of our lowcode/nocode connectors, and/or our native integrations. If you want to store and access data longer than 24 hours, please write it to your preferred endpoint using one of these methods.
For Google Cloud users, we also offer a native BigQuery storage integration. If you activate this option, Confection will make three attempts to write your account data to BigQuery before the 24-hour expiration point. We migrate all data as a JSON object that includes a UUID and all the data associated with it.
To set up the BigQuery integration, visit "My Account" in your Confection dashboard. Under "Data Storage," select "Send to Google BigQuery."
Next, visit your BigQuery Console. Click the vertical dots (⋮) beside the project name that will contain the Confection dataset, and select "Create dataset." (If you need to create project, see this list of instructions.)
Name the dataset
confection. (Note, this is case sensitive.
Confection won't work.
confection will.) Then, select the relevant region, set an expiration timeframe (optional), and edit the advanced options as they're relevant to you. Lastly, click "Create Dataset."
Next, click the right-facing triangle beside your project name, click the vertical dots (⋮) beside the "confection" dataset, and select "Share." Click "Add Principal," and add
[email protected] in the "New principals" field. In the "Role" dropdown, select "BigQuery" > "BigQuery Data Editor." This will give Confection write access to the dataset. Then, select "Save."
Lastly, copy your project name --
premium-trainer-360701 in the video -- and add it to the field in the "My Account" section of your Confection account. Click "Save Changes" to begin writing your Confection account data to BigQuery.
That's it. You're done.
After you complete the steps above -- and after your account has had a chance to write data into BigQuery -- you'll see a new table under your Confection dataset called
leads. It will contain a list of UUIDs and data associated with those UUIDs.
Questions or comments about using Confection with BigQuery (Google Cloud)? Leave them below.
You can also use the chat app in the lower right corner.