This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Bigquery storage conversion from logical to compressed

Posted on 07-06-2023 05:12 AM
rkusj
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Hi,

We have schemas in Bigquery where we do daily ingestion to raw and then refine layer.

We are currently planning to move logical storage to compressed storage in order to save the cost but I wanted to check

1. would it impact our daily ingestion process in same BQ schemas?

2. The newly ingested data will belong to logical storage or compressed storage?

Thanks.

Solved Solved
2 7 2,127
Topic Labels
Jump to Solution
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
ms4446
Staff
Reply posted on --/--/---- --:-- AM
  1. Moving from logical to compressed storage will not impact your daily ingestion process. You can continue to ingest data into the same schemas as before.
  2. The newly ingested data will belong to compressed storage. This is because compressed storage is the default storage type for new tables.

Here are some things to keep in mind when moving to compressed storage:

  • Compressed storage can save you up to 50% on storage costs.
  • Compressed storage can slightly increase query latency.
  • You cannot downgrade a table from compressed storage to logical storage.

View solution in original post

Jump to Solution
7 REPLIES 7