Data Types: All Columns as STRING

If your data is messy (=multiple data types appearing within 1 column) and you want to make sure that everything will be successfully uploaded to BigQuery, you should use “All Columns as STRING” in the Data Types dropdown:

All Columns as STRING

There are no rules for any formatting but you will likely need to do some CASTing in BigQuery – e. g. if you need to use some date related SQL functions, you’ll have to cast your STRING date column to DATE data type first.

Back to Help Center  Buy License Now

3 thoughts on “Data Types: All Columns as STRING

  1. Pingback: How to Run Your First Upload – Mythical Reports

  2. Jonas Reply

    Hello,

    I am using your igQuery Uploader for Google Sheets and I have the setting “All columns as STRING” active, but everytime I have string like “0100” starting something with “0” it is loaded as string, but as “100”, initial zero(s) are trimmed. Can you repair the behaviour as this settings is not working as expected?

    Thank you for you reply.
    Jonas Mimra

    • admin Post authorReply

      Hi Jonas,
      this is a bug indeed. We’ll have a look at it and get back to you.

      Daniel

Leave a Reply

Your email address will not be published. Required fields are marked *