Configuration #

kind: source
spec:
  # Source spec section
  name: facebookmarketing
  path: cloudquery/facebookmarketing
  registry: cloudquery
  version: "v4.9.4"
  tables: ["*"]
  destinations: ["postgresql"]
  # Learn more about the configuration options at https://cql.ink/facebookmarketing_source
  spec:
    # Facebook Marketing Spec section
    # You can find the ad_account_id in the Facebook Ads Manager: https://www.facebook.com/ads/manager/accounts/
    ad_account_id: "${AD_ACCOUNT_ID}"
    # See the "authentication section" on how to create an access token
    access_token: "${ACCESS_TOKEN}"

Authentication #

1. Create a business app in the Meta App dashboard. See Facebook's documentation. Make sure to choose the "Business" application type, and to link it to your business account.

• Add the "Marketing API" capability to your application. You should now see a dropdown "Marketing API" menu. In this dropdown, under Tools, you will be able to generate your access token. See also Facebook's documentation
• 
• 
• You will also need to find your ad_account_id, which you can find in the Facebook Ads Manager. (See documentation).

Configuration #

• concurrency (integer) (optional) (default: 10000)

  A best effort maximum number of Go routines to use. Lower this number to reduce memory usage.
• scheduler (string, optional) (default: dfs)

  The scheduler to use when determining the priority of resources to sync. Supported values are dfs (depth-first search), round-robin, shuffle and shuffle-queue.

  For more information about this, see performance tuning.