DB population with one file

[avishniakov-smwb]

Currently we can't populate DB with a single SQL file, since Firebolt core does not support multiple statements in it. So I have to run population sql statement-by-statement. That is more or less fine until we recall that each time it raises up a connection, so auto statement split wouldn't work: USE DATABASE testdb won't be applied to next statements.

Obviously there are ways like -d key for fbcli command, or use fully-qualified name like testdb.public.test_table, but they all look weird.

Are there any plans about first-class support for multi-statement files?

[gilcizer1]

Hi @avishniakov-smwb, how did you try to pass the file into Firebolt? did you try to use any SDK or an HTTP call?
can you provide the command line you used?