bigquery.tiktok_ads

TikTok Ads data into BigQuery

Every Datanable plan includes a managed BigQuery warehouse: partitioned tables, incremental loads, and schema tracked over time. Or point it at your own project and keep the same pipeline.

TikTok AdsBigQuery

The pipeline behind every TikTok Ads table

1ExtractPull TikTok Ads data via the official API on a schedule
2ValidateRun quality checks: nulls, duplicates, schema drift
3LoadWrite to partitioned, incremental BigQuery tables
4ModelTransform into clean, ready-to-query tables

Managed BigQuery, or your own project

Managed by DatanableYour own project
SetupNothing to configureGrant a service account access
Storage costIncluded in your planBilled on your GCP project
Data residencyEUWhatever your project uses
RetentionAs long as the connection is activeAs long as you keep the tables

TikTok Ads to BigQuery: FAQ

What does the managed BigQuery warehouse cost?
It's included in every Datanable plan, storage and compute for your synced tables are not billed separately.
Can I point Datanable at my own BigQuery project instead?
Yes, on the Enterprise plan. Grant the Datanable service account write access and we load into your project using the same pipeline, partitioning included.
Are loads incremental or full refresh?
Incremental by partition. Only new or changed days are reprocessed, so daily syncs stay fast even on large accounts.
Which regions are supported?
EU on the managed warehouse; any region your project uses when you bring your own BigQuery project.
What is Tiktok Ads?
TikTok Ads is an advertising platform that allows businesses to create and display ads to TikTok's global user base, using engaging formats like video, images, and interactive content.
Do I have to pay for a Data Warehouse?
No, we provide you with a Managed Data Warehouse that enables ultra-fast dashboards at no additional cost.
Can I use my own Data Warehouse?
Yes, with the Enterprise Plan. Please reach out to us through the contact form.
Do I need a Data Engineer or a Data Analyst to use Datanable?
No, Datanable is a no-code platform, offering powerful Data Engineering capabilities to everyone.
Where is Datanable based?
Datanable is based in France.

See it running on your own accounts.

Seven days free, no credit card required. Connect your first source in a few minutes.