SNOW-1858362: Cannot perform runtime binding on a null reference when using PUT command for a single csv file

[bianca01276]

Please answer these questions before submitting your issue.
In order to accurately debug the issue this information is required. Thanks!

1. What version of .NET driver are you using?
   4.2.0 but I tried with 4.1.0 and there is the same issue

2. What operating system and processor architecture are you using?
   Windows

3. What version of .NET framework are you using?
   .net 8

4. What did you do?
   I have a csv file and I want to add it in a stage with put command. I opened the connection
   cmd.CommandText = $"PUT file://monthly.csv @import.file AUTO_COMPRESS=TRUE SOURCE_COMPRESSION=GZIP PARALLEL=3";

5. What did you expect to see?
   The command executed successfully
   I receive this error Snowflake.Data.Client.SnowflakeDbException: 'Error: IO operation failed. Error: One or more errors occurred. (Cannot perform runtime binding on a null reference) SqlState: , VendorCode: 270058, QueryId: 01b91049-0305-2703-0000-3402747595e3'

This error appears here:

most probably the issue is due to the fact that the fields are checked in Uppercase but in val they appear in lowercase...

7. Can you set logging to DEBUG and collect the logs?

   https://community.snowflake.com/s/article/How-to-generate-log-file-on-Snowflake-connectors

   There is an example in READMD.md file showing you how to enable logging.

   Before sharing any information, please be sure to review the log and remove any sensitive
   information.

[sfc-gh-dszmolka]

hi - thanks for filing this issue with us. what is @import.file here ? is it supposed to be database.schema ? If yes, then Stage name is missing.
can you please try:

1. either specifying db and schema in connection string, then only use Stage name with PUT file://<path to file> @mystage ..rest of the params
2. or, using Stage FQDN like PUT file://<path to file> @mydb.myschema.mystage ...rest of the params
3. to rule out driver related issues, you can try any other Snowflake client driver using the exact same syntax and see if it works

let me know please.

[sfc-gh-dszmolka]

marking this one as closed due to inactivity but please do comment with the details if you still face the issue and we can reopen