Dawid Nawrot
- 活动总数 72
- 最后的活动
- 成员加入日期
- 关注 0 名用户
- 关注者数 0 名用户
- 投票数 3
- 订阅数 23
-
创建于 Big 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) -
创建于 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? -
创建于 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... -
创建于 Copying 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... -
创建于 Modify 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... -
创建于 Override 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... -
创建于 BigQuery Execute Immediate with a variable
已回答I 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... -
创建于 Inspect BigQuery information schemas
已回答I 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. -
创建于 Disable subquery closing bracket indentation
已回答Sometimes 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... -
创建于 Show actual keys of data type STRUCT
已回答Looks 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?