Dawid Nawrot
- Total activity 72
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 3
- Subscriptions 23
-
Created Big Query - SELECT EXCEPT REPLACE doesn't work
AnsweredThis structure is failing in BigQuery: SELECT table.* EXCEPT(type) REPLACE(IF(something IS NULL, 10, 100) AS something2) -
Created Close console window
I assigned a keyboard shortcut CTRL+W to "Close Active Editor" but it doesn't work on console windows. Is there a special keymap for console windows? -
Created BigQuery - query returns undefined variable but it's okay in console
I'm playing with some dynamic sql like this: DECLARE columns STRING;SET columns = ( SELECT STRING_AGG(CONCAT('COUNT(DISTINCT `', column_name, '`) AS ', column_name, '_count')) FROM dateset.INF... -
Created Copying data from Data View - replace NULL
AnsweredVery often I copy the data from the Data View in order to, for example, use it as an input for some data modelling tests but the problem I have is that the NULLs are empty, so the data may look lik... -
Created Modify table window - can we improve it?
AnsweredModify Table window could use a bit of love from the Team to make it more usable: 1. Show column attributes as columns in the window 2. #1 would mean we can see all details at once. Right now we ha... -
Created Override settings per project
AnsweredIs it possible to change a setting like number of spaces for indentation, per project? I got used to using 2 spaces now (even though it's not necessary) but I still work with data models in differe... -
Created BigQuery Execute Immediate with a variable
AnsweredI have a questy that in a nutshell looks like following: DECLARE variable STRING; SET variable = (SELECT STRING_AGG(field) FROM table); EXECUTE IMMEDIATE FORMAT("""SELECT * FROM (%t)""", variable... -
Created Inspect BigQuery information schemas
AnsweredI was wondering if having onhover information about tables/views like __TABLES__ or INFORMATION_SCHEMA is possible? I can't seem to find a way to add it to the list of inspected schemas. -
Created Disable subquery closing bracket indentation
AnsweredSometimes I have a simple query like this: SELECT dim, COUNT(*), FROM abc GROUP BY 1 and then I wrap it in another select. I managed to disable auto format on closing ) in a query like th... -
Created Show actual keys of data type STRUCT
AnsweredLooks like when a column is of a datatype STRUCT, we can't see the key names, only "v" and "f" Can this be changed in Settings or is it a bug?