Questions about Airbyte integration and usage with specific connectors

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

User has questions about OAuth flow for Shopify source, using Postgres destination with namespaces and custom definitions, and OAuth flow for various sources like Amazon Ads and Google Analytics Data API.


Question

Hello Team, I have a few questions regarding the integration and usage of Airbyte, specifically with the Shopify source and other connectors. I would appreciate your guidance on the following:

  1. Shopify Source and OAuth Flow: I noticed that there are no options to initiate the OAuth flow via the Airbyte APIs for the Shopify source. Assuming I am using Airbyte Cloud, how can I pull data for any store? In the Create Source API, what should I send in the secretId? Should I use a user credential like an Admin API token instead?
  2. Postgres Destination with Namespaces and Custom Definitions: When using PostgreSQL as the destination with namespaces and custom definitions, does writing to the database result in the deletion of foreign keys? Is there no foreign key constraint in the schema, requiring manual references instead?
  3. OAuth Flow for Various Sources: For the connectors such as Amazon Ads, Amazon Seller Partner, Google Search Console, and Google Analytics Data API, I am using Airbyte Cloud and have received the secretId via the OAuth flow. For these connectors, should I only send the secretId in the Create Source API, or do I need to include the credentials object as defined in the documentation (which appears to be intended only for the open-source version)?
    Thank you for your assistance with these queries. I look forward to your prompt response.

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["airbyte", "integration", "shopify-source", "oauth-flow", "postgres-destination", "namespaces", "custom-definitions", "foreign-keys", "oauth-flow", "amazon-ads", "google-analytics-data-api", "secretid", "credentials-object"]