What is the BigQuery Integration?
The BigQuery integration gives you a copy of your subscription program data in your BigQuery data warehouse. You can analyze this data with SQL, combining it with other business datasets for deeper insights. Data refreshes every 24 hours by default, with the option to increase to every 4 hours (up to 6 times per day).
What kind of data can I expect to see?
All data available through code.skio.com is included in this integration, delivered in raw tables within your warehouse.
How do I set this up?
Reach out to your Merchant Success Manager or success@skio.com.
Who pays for the data access?
Skio will create and maintain a dataset which is shared to a user you control. Queries on this dataset will be billed by Google Cloud to the user who launched the query.
How much does this feature cost?
Most merchants will pay less than $5 per month to use this feature.
For higher-volume stores or advanced use cases, the cost may be closer to $10 per month, and in rare cases could be up to $20 per month. Overall, the majority of merchants will pay under $5 per month.
What if I use a different data warehouse?
Skio can also produce a periodic export of the dataset to Google Cloud Storage as a CSV. This CSV can be ingested into any standard data warehouse.
Are there any alerts or logs if syncs fail?
Not currently. However, you can check for issues by reviewing the timestamps of the most recent data to confirm whether syncs are running as expected.