Dawid Nawrot

Avatar
  • Total activity 55
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 3
  • Subscriptions 16
  • Created

    BigQuery Execute Immediate with a variable

    Answered
    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...
    • 2 followers
    • 1 comment
    • 0 votes
  • Created

    Inspect BigQuery information schemas

    Answered
    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.
    • 3 followers
    • 2 comments
    • 0 votes
  • Created

    Disable subquery closing bracket indentation

    Answered
    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...
    • 2 followers
    • 4 comments
    • 0 votes
  • Created

    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?
    • 1 follower
    • 0 comments
    • 0 votes
  • Created

    Show table data preview on mouse hover

    I'm not sure whether I disabled it somehow but there was a very useful feature to not only show the schema of the table on hover but we could also see a small preview of the data. I can't find a wa...
    • 1 follower
    • 0 comments
    • 0 votes
  • Created

    Understanding settings for Project / Driver / Data Source

    I want to start working with code styling settings in more detail but I'm never sure which settings to change. I'm using BigQuery driver and have a source but the Code Style applied in the properti...
    • 1 follower
    • 0 comments
    • 0 votes
  • Created

    Hard/soft wrap on type & paste

    I'm still having problems configuring my DataGrip to what I would like it to be.   Here is a screenshot:   I have hard wrap guideline but as I type I would like the code to wrap with breaking only...
    • 2 followers
    • 10 comments
    • 0 votes
  • Created

    Visual representation of boolean fields

    Completed
    There used to be a nice bright blue tick checkbox for boolean fields, which made the visual scanning for the right value much easier and more pleasant. Now it seems we just get a dot that could jus...
    • 3 followers
    • 3 comments
    • 0 votes
  • Created

    Hard wrap on paste

    Answered
    Still trying to get the wraps to work correctly for me. It's working when I type but when I paste, the code goes beyond the 100 characters limit I set. Any chance I can have the same effect on copy...
    • 2 followers
    • 1 comment
    • 0 votes
  • Created

    Problems with CTE

    Answered
    Since there's no SQL dialect and I have to use General SQL, the CTEs are ignored in my ways: 1. Their syntax highlighting doesn't work 2. When cursor is inside CTE CTRL+Enter doesn't work  3. When ...
    • 3 followers
    • 2 comments
    • 1 vote