Generate warehouse destination setup script | LaunchDarkly

curl -X POST https://app.launchdarkly.com/api/v2/destinations/projects/projKey/environments/envKey/kinds/kind/setup \
     -H "Authorization: <apiKey>" \
     -H "Content-Type: application/json" \
     -d '{}'

{
  "script": "CREATE SCHEMA launchdarkly_data_export;\nCREATE TABLE launchdarkly_data_export.feature_flags (\n  flag_key VARCHAR PRIMARY KEY,\n  flag_name VARCHAR,\n  created_at TIMESTAMP\n);\nGRANT USAGE ON SCHEMA launchdarkly_data_export TO ROLE data_export_role;\nGRANT SELECT ON ALL TABLES IN SCHEMA launchdarkly_data_export TO ROLE data_export_role;",
  "publicKey": "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAv1X9zQ7v5Xq9J7Q2vYxF\nbZx1Q9v+3Z9Xq1v5Xq9J7Q2vYxFbZx1Q9v+3Z9Xq1v5Xq9J7Q2vYxFbZx1Q9v+3Z9\nXq1v5Xq9J7Q2vYxFbZx1Q9v+3Z9Xq1v5Xq9J7Q2vYxFbZx1Q9v+3Z9Xq1v5Xq9J7\nQ2vYxFbZx1Q9v+3Z9Xq1v5Xq9J7Q2vYxFbZx1Q9v+3Z9Xq1v5Xq9J7Q2vYxFbZx1\nQIDAQAB",
  "publicKeyPkcs8": "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQC/Vf3NDu/ler0ntDa9jEVtnHVD\n2/7dn1erW/ler0ntDa9jEVtnHVD2/7dn1erW/ler0ntDa9jEVtnHVD2/7dn1erW/\nler0ntDa9jEVtnHVD2/7dn1erW/ler0ntDa9jEVtnHVD2/7dn1erW/ler0ntDa9jE\nVtnHVD2/7dn1erW/ler0ntDa9jEVtnHVD2/7dn1erW/ler0ntDa9jEVtnHVD2/7dn\n1erW/ler0ntDa9jEVtnHVD2/7dn1erWQIDAQAB"
}

Generate the SQL setup script required to prepare a warehouse for LaunchDarkly Data Export. For Snowflake, this also generates a key pair.

Authentication

Authorizationstring

API Key authentication via header

Path parameters

projKeystringRequiredformat: "string"

The project key

envKeystringRequiredformat: "string"

The environment key

kindstringRequiredformat: "string"

The destination kind (snowflake-v2, redshift)

Response

Generate warehouse destination setup script response

scriptstring

The SQL setup script to run in your data warehouse

publicKeystring

The RSA public key (Snowflake only) to store as the destination public_key

publicKeyPkcs8string

The PKCS8 RSA public key (Snowflake only)

Errors

400

Bad Request Error

401

Unauthorized Error

403

Forbidden Error

429

Too Many Requests Error