Dawid Nawrot
- Total activity 72
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 3
- Subscriptions 23
-
Dawid Nawrot created a post, AnsweredBig Query - SELECT EXCEPT REPLACE doesn't work
This structure is failing in BigQuery: SELECT table.* EXCEPT(type) REPLACE(IF(something IS NULL, 10, 100) AS something2) -
Dawid Nawrot created a post, 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? -
Dawid Nawrot created a post, 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... -
-
-
Dawid Nawrot created a post, AnsweredCopying data from Data View - replace NULL
Very 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... -
Dawid Nawrot commented, -
Dawid Nawrot created a post, AnsweredModify table window - can we improve it?
Modify 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... -
Dawid Nawrot created a post, AnsweredOverride settings per project
Is 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... -