Google BigQuery Simplified Import Form

Comments

6 comments

  • Official comment
    Bhavik Shah Senior Product Manager
    Answer Pro
    Great Answer

    Felipe Starling BigQuery connector is now available on Celigo Platform that provides simplified import view that is similar to other DW connectors. Follow the below article for more info.  

    https://docs.celigo.com/hc/en-us/articles/360042825892-Set-up-a-connection-to-Google-BigQuery

  • Stephen Brandt Documentation Manager Community moderator
    Celigo University Level 4: Legendary
    Engaged
    Great Answer
    Top Contributor

    Thanks for your feedback, Felipe Starling

    1. Google BigQuery isn't the standard app. That is, its data structure is very customizable per user requirements, and we've found it challenging to anticipate the typical data/types that a customer might set up. It's why the "adapter" (internal parlance for built-in API-aware exports and imports) is following the connector with such a long development lag.

      That's unlike Salesforce, with predictable export and import assumptions. We've done our best in the template to accommodate common BigQuery imports for a variety of possible use cases, which is why it is so complicated. The import allows you to specify your HTTP endpoint and modify the JSON-formatted records to pass to the BigQuery API.

    2. We don't yet have a date for promising a full-blown template user guide, other than the readme, but I can assure you that this request will bump it up in priority. 

    I'll try to remember to follow up with your when there's progress to report. 

    0
  • Felipe Starling

    Got it. Could you send me the link to the readme. Thanks!

    0
  • Stephen Brandt Documentation Manager Community moderator
    Celigo University Level 4: Legendary
    Engaged
    Great Answer
    Top Contributor

    I'm sorry. I saw your integration and heard about your project today in Office Hours today, and I also know of a Salesforce – BigQuery template that's slated for future work. I wrongly assumed that you were working with a preview version of that template, instead of the built-from-scratch integration that you inherited.

    I don't have an estimated date of arrival for that template. In general, we don't have complete point-to-point documentation for integration with all supported APIs, unless they're already bundled as an Integration App or template. 

    0
  • Kelly OConnor

    Stephen, 

    Is there a way to get the preview version of the SF - BigQuery template? 

    0
  • Stephen Brandt Documentation Manager Community moderator
    Celigo University Level 4: Legendary
    Engaged
    Great Answer
    Top Contributor

    Hi, Kelly OConnor. I'll pass along the additional interest/demand. 

    According to the schedule, it's near the top of the list for 2021. I'll post any updates, as they happen. 

    Thanks for the up-vote. 

    0

Please sign in to leave a comment.