What is the BigQuery integration?
The BigQuery integration gives you direct access to your subscription program data in your own BigQuery data warehouse. You can analyze this data using SQL and combine it with other business datasets (like order history, customer behavior, or marketing performance) to unlock deeper insights into your subscription business.
The BigQuery integration is ideal if you:
Want to run custom SQL queries on your subscription data
Need to combine Skio data with other business data sources (e.g., Shopify orders, marketing analytics, inventory systems)
Use BigQuery or Google Cloud as your primary data warehouse
Have a data team or analyst who works with SQL and wants direct access to raw subscription data
Want to build custom dashboards or reports outside of Skio's built-in analytics tools
What kind of data is included?
Data refreshes every 24 hours by default, with the option to increase refresh frequency to every 4 hours (up to 6 times per day).
All data available through code.skio.com is included in this integration, delivered as raw tables within your BigQuery warehouse. This includes subscription records, customer data, order history, and related metrics.
Additional resources
FAQ
Who pays for the data access?
Skio creates and maintains the dataset, which is shared to a user you control. Queries on this dataset are 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. You can toggle this on during integration setup.
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.
What if I don't have access to my Google Cloud project?
Contact your Google Cloud administrator to request access or to have them complete the setup steps on your behalf.
How often is my Skio data updated in BigQuery?
Data refreshes every 24 hours by default. You can request to increase the refresh frequency to every 4 hours (up to 6 times per day). Contact your Merchant Success Manager to adjust your sync schedule.
I don’t see the option to add or remove users from the BigQuery Integration, or I get an error that BigQuery Integration is not configured for my store?
If you see a BigQuery Integration is not configured for your store message when accessing the integration from your Skio Dashboard, reach out to Support at help@skio.com.