https://evidence.dev logo
Join Slack
Powered by
# sqltools
  • s
    Hello All. I am trying to install bigquery for sqltools in vscode when using a devcontainer. nodejs and npm is installed in the dev container and is detected. When I try to test a connection using service account credentials, I am being asked to install some nodejs packages. A terminal is opened and the npm command is executed; however, the progress spinner freezes and never completes. If I ctrl-C this and run the command myself, but with --verbose, the command completes, however, when I click test connection it tells me I need to install the missing packages.
    b
    • 2
    • 13
  • s
    How do I enable pagination? This is what I am seeing:
  • s
    image.png
  • b
    hmm
  • b
    seems like this is a bug with SQLTools: https://github.com/mtxr/vscode-sqltools/issues/694
  • b
    rather than the bigquery plugin
  • d
    hoping it's not too presumptuous to ask for a hand here -
  • d
    Is there a way to get additional projects to appear under a Connection in the explorer panel, in the way that we would see them in the BQ IDE?
  • d
    the more i hunt around, the more it appears that this is a SQLTools issue. boo!
  • d
  • b
    I think you can add different projects individually
  • b
    which is obviously a huge pain
  • d
    I assume a separate connection for each - not clear on how to connect directly to, say, "bigquery-public-data"
  • b
    exactly
  • b
    I think there is also another BQ specific VScode extension: https://marketplace.visualstudio.com/items?itemName=minodisk.bigquery-runner
  • b
    (not authored by us)
  • d
    i have that one as well
  • b
    but when i tested it, it had multi project support?
    🤔 1
  • d
    i'll look at this as well
  • b
    The problem in general with this feature is that there is no query you can run in BigQuery to get all the different projects, which is how SQLTools gets information
  • b
    Under the hood, it runs queries like
    Copy code
    select * from information_schema.tables
    to populate the list of tables in the explorer
  • d
    yeah, i was just poking around and that's an issue - my SA doesn't have access to that so I wouldn't expect it to auto-populate
  • d
    within SQLTools, though, even trying to add "bigquery-public-data" as a database under a connection is proving elusive
  • b
    I'm not sure I've tried public datasets now I think about it
  • b
    I've always been using our company internal data
  • b
    Feel free to open an issue for it, and next time I get around to updating this extension, I'll look into it
  • b
    (this is a very side of desk project for me!)
  • d
    i appreciate your support of it - super useful tool. I'll poke around a bit too - I have written zero TS though. ha ha
  • b
    This was also my case before I wrote this extension, so it's 50% me 50% chatGPT
    😀 1
  • d
    well that's heartening! ha ha