WRITE TO GOOGLE BIGQUERY USING TABLEAU PREP

STEP 1: CREATE A PUBLISHED DATA SOURCE

  1. Click the plus icon on a step and select Add Output.
  2. The output pane opens and shows you a snapshot of your data.
  3. From the Save output to drop-down list, select the Published data source (Publish as the data source in previous versions).
    Complete the following fields:
  • Server (Tableau Prep Builder only): Select the server to publish the data source and extract. If you aren’t signed in to a server, you will be prompted to sign in.
    Note: Starting in Tableau Prep Builder version 2020.1.4, after you sign in to your server, Tableau Prep Builder remembers your server name and credentials when you close the application. The next time you open the application, you are already signed into your server.
    On the Mac, you may be prompted to provide access to your Mac keychain so Tableau Prep Builder can securely use SSL certificates to connect to your Tableau Server or Tableau Online environment.
  • Project: Select the project where you want to load the data source and extract.
  • Name: Enter a file name.
  • Description: Enter a description for the data source.
  • Create table: This option creates a new table or replaces the existing table with the new output.
  • Append to the table: This option adds the new data to your existing table. If the table doesn’t already exist, a new table is created, and subsequent runs will add new rows to this table.
  1. Click Run Flow to run the flow and publish the data source.
  2. (optional) Click on the Custom SQL tab and enter your SQL script. You can enter a script to run Before and After the data is written to the table.

STEP 2: DATA VALIDITY

  • No match: Field is ignored: Fields exist in the flow but not in the database. The field won’t be added to the database table unless you select the Create table write option and perform a full refresh. Then the flow fields are added to the database table and use the flow output schema.
  • No match: Field will contain Null values: Fields exist in the database but not in the flow. The flow passes a Null value to the database table for the field. If the field does exist in the flow but is mismatched because the field name is different, you can navigate to a cleaning step and edit the field name to match the database field name.
  • Error: Field data types do not match: The data type assigned to a field in both the flow and the database table you are writing your output must match; otherwise, the flow will fail. You can navigate to a cleaning step and edit the field data type to fix this.

STEP 3: WRITE BACK IMPLEMENTATION

STEP 4: CONNECTION INFORMATION

SCHEMA COMPONENTS

COLUMN NAMES

  • _TABLE_
  • _FILE_
  • _PARTITION
  1. From the Save output to the drop-down list, a select Database table.
  2. In the Connection drop-down list, select the database connector where you want to write your flow output.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Rajeev Pandey

Rajeev Pandey

I’m Rajeev, Tableau Zen Master ,Tableau Ambassador, Tableau Featured Author, Data Evangelist from India.