Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r089

...

  1. Select location: Navigate the BigQuery browser to select the database and table to which to publish.
    1. To create a new table, click Create a new table.
  2. Select table options:
    1. Table name:

      Info

      NOTE: BigQuery does not support destinations with a dot (.) in the name. For more information, see https://cloud.google.com/bigquery/docs/tables#table_naming.

      1. New table: Enter a name for it. You may use a pre-existing table name, and schema checks are performed against it.
      2. Existing table: You cannot modify the name.
    2. Allow strict rules for type mismatch: 
      D s ed
      nottrue
      editionsgdple

      1. When enabled, the data types and their formatting set in the 

        D s webapp
         must match the types and formatting supported in BigQuery. 

        Info

        NOTE: By default, data is published to BigQuery using strict data type matching rules. When there are mismatches between

        D s item
        itemdata types
        and BigQuery data types, the publication fails.

      2. When disabled, 
        D s item
        itemdata types
         are written to the closest approximation of time and formatting in BigQuery. 
      3. For more information, see BigQuery Data Type Conversions.
    3. Output database: To change the database to which you are publishing, click the BigQuery icon in the sidebar. Select a different database.
    4. Publish actions: Select one of the following.
      1. Create new table every run: Each run generates a new table with a timestamp appended to the name.
      2. Append to this table every run: Each run adds any new results to the end of the table.
      3. Truncate the table every run: With each run, all data in the table is truncated and replaced with any new results.
      4. Drop the table every run: With each run, the table is dropped (deleted), and all data is deleted. A new table with the same name is created, and any new results are added to it.

      5. Merge the table every run: This publishing option merges the rows in your results with any existing rows in the target BigQuery table. For more information, see Merge Table Operations below.

  3. To save the publishing action, click Add or Update.

...