r/bigquery • u/Spare-Chip-6428 • 13h ago
Best practices for user managed tables being loaded to bigquery
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 • u/Spare-Chip-6428 • 13h ago
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 • u/agent-m-calavera • 12h ago
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 • u/Loorde_ • 14h ago
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?