topic Re: Snowflake query layer won't copy to local geodatabase in ArcGIS Pro SDK Questions

Snowflake query layer won't copy to local geodatabase

MK13 — Tue, 30 Jul 2024 21:44:02 GMT

I am attempting to copy a snowflake query layer to a local geodatabase but the GP tool fails with no error messages or any messages for that matter. What could be the issue? I have confirmed that the snowflake table gets created as I return the count of rows found.

@NarelleChedzey @UmaHarano @Wolf @CharlesMacleod

Re: Snowflake query layer won't copy to local geodatabase

GKmieliauskas — Wed, 26 Jun 2024 08:28:54 GMT

Hi,

"conversion.ExportTable" geoprocessing tool has 3 mandatory parameters. One is missed in your parameters list (use_field_alias_as_name). I would recommend to call ExecuteToolAsync with GP events processing (callback) as in thread. In OnValidate event you will get information about wrong parameters and etc.

More info here

Re: Snowflake query layer won't copy to local geodatabase

MK13 — Wed, 26 Jun 2024 19:39:41 GMT

@GKmieliauskas That was helpful, thank you. I was able to retrieve the error message as below:

C:/Users/myuserid/AppData/Local/Temp/ArcGISProTemp49672/562bf87bd4889d4e2094a30b9462ccc7.sde/EDW.ODS.%25mylyrCsharp1 does not exist or is not supported</msg>}

What I am now wondering is why the snowflake query layer/table that was created by the line below

var outTable = snowflakeSde.OpenTable(k) as Table;

doesn't exist or is not supported since again, I can get the count of the rows so I know that it exists.

Re: Snowflake query layer won't copy to local geodatabase

MK13 — Mon, 01 Jul 2024 14:41:10 GMT

@GKmieliauskas @NarelleChedzey @UmaHarano @Wolf @CharlesMacleod

Re: Snowflake query layer won't copy to local geodatabase

UmaHarano — Tue, 30 Jul 2024 21:32:06 GMT

@MK13

Regarding line 8, Is mySnowFlakeQuery a variable? If so, it needs to be in curly braces. (Just checking)

var query1 = $"mySnowFlakeQuery";

Re: Snowflake query layer won't copy to local geodatabase

UmaHarano — Tue, 30 Jul 2024 21:33:23 GMT

@MK13

Regarding line 8, Is mySnowFlakeQuery a variable? If so, it needs to be in curly braces. (Just checking)

Re: Snowflake query layer won't copy to local geodatabase

MK13 — Tue, 30 Jul 2024 21:42:45 GMT

Hi Uma, I just used $"mySnowFlakeQuery" as a substitution for the actual query that I am using. I didn't want to expose my actual query to the public but it's a valid sql query. Also, I've been working with someone in tech support and they let me know that they re-produced this issue and think that it might be a bug.