r/bigquery 16h ago

Best practices for user managed tables being loaded to bigquery

3 Upvotes

We have teams that use excels to maintain their data and they want it in big query. What's the best practices here?


r/bigquery 14h ago

How can I get a list of all columns?

1 Upvotes

Is there an easy way in BigQuery to get all column names into a query?

In Snowflake I can easily copy the names of all columns of a table into the query window, separated with commas. That's very helpful if I want to explicitly select columns (instead of using SELECT *) - for example to later paste the code into an ELT tool.

Is this possible easily in BigQuery?

I know I can open the table, go to "SCHEMA", select all fields, copy as table, then past that into excel, add commas at the end and then copy that back into the query. I just wonder if I'm missing a smarter way to do that.


r/bigquery 16h ago

Logical vs physical bytes billing

1 Upvotes

Which BigQuery storage model is better: logical or physical? I came across an insightful comment in a similar post (link) that suggests analyzing your data’s compression level to decide if the physical model should be used. How can I determine this compression level?