我正在尝试使用 .Net 雪花数据为 ADF 构建雪花连接器,但由于用户和密码不正确,构建测试失败 我在 azure 上使用雪花,任何人都可以建议我需要parameter.json
文件中添加更多配置吗 请找到以下错误。
已经在没有密码测试的情况下尝试过。
https://github.com/snowflakedb/snowflake-connector-net/
错误信息: Snowflake.Data.Client.SnowflakeDbException : 指定了不正确的用户名或密码。 堆栈跟踪: at Snowflake.Data.Client.SnowflakeDbConnection.Open() in D:\LululemonResources\VS\snowflake-connector-net-master\snowflake-connector-net-master\Snowflake.Data\Client\SnowflakeDbConnection.cs:line 113 at Snowflake.Data.Tests.SFConnectionIT.TestConnectWithDifferentRole() in D:\LululemonResources\VS\snowflake-connector-net-master\snowflake-connector-net-master\Snowflake.Data.Tests\SFConnectionIT.cs:line 214 跳过测试OktaConnection 跳过的测试SSOConnectionWithUser 跳过的测试SSOConnectionWithWrongUser 失败的测试切换Db 错误信息: Snowflake.Data.Client.SnowflakeDbException : 指定了不正确的用户名或密码。 堆栈跟踪: at Snowflake.Data.Client.SnowflakeDbConnection.Open() in D:\LululemonResources\VS\snowflake-connector-net-master\snowflake-connector-net-master\Snowflake.Data\Client\SnowflakeDbConnection.cs:line 113 at Snowflake.Data.Tests.SFConnectionIT.TestSwitchDb() in D:\LululemonResources\VS\snowflake-connector-net-master\snowflake-connector-net-master\Snowflake.Data.Tests\SFConnectionIT.cs:line 160 失败的测试未知连接属性 错误信息: Snowflake.Data.Client.SnowflakeDbException : 指定了不正确的用户名或密码。 堆栈跟踪: at Snowflake.Data.Client.SnowflakeDbConnection.Open() in D:\LululemonResources\VS\snowflake-connector-net-master\snowflake-connector-net-master\Snowflake.Data\Client\SnowflakeDbConnection.cs:line 113 at Snowflake.Data.Tests.SFConnectionIT.TestUnknownConnectionProperty() in D:\LululemonResources\VS\snowflake-connector-net-master\snowflake-connector-net-master\Snowflake.Data.Tests\SFConnectionIT.cs:line 144 失败的测试选择语句 错误信息: Snowflake.Data.Client.SnowflakeDbException : 指定了不正确的用户名或密码。 堆栈跟踪: at Snowflake.Data.Client.SnowflakeDbConnection.Open() in D:\LululemonResources\VS\snowflake-connector-net-master\snowflake-connector-net-master\Snowflake.Data\Client\SnowflakeDbConnection.cs:line 113 at Snowflake.Data.Tests.SFDbAdaptorIT.TestSelectStatement() in D:\LululemonResources\VS\snowflake-connector-net-master\snowflake-connector-net-master\Snowflake.Data.Tests\SFDbAdaptorIT.cs:line 22 失败的测试取消执行异步 错误信息: Snowflake.Data.Client.SnowflakeDbException : 指定了不正确的用户名或密码。 堆栈跟踪: at Snowflake.Data.Client.SnowflakeDbConnection.Open() in D:\LululemonResources\VS\snowflake-connector-net-master\snowflake-connector-net-master\Snowflake.Data\Client\SnowflakeDbConnection.cs:line 113 at Snowflake.Data.Tests.SFDbCommandIT.TestCancelExecuteAsync() in D:\LululemonResources\VS\snowflake-connector-net-master\snowflake-connector-net-master\Snowflake.Data.Tests\SFDbCommandIT.cs:line 402 失败的测试取消查询 错误信息: Snowflake.Data.Client.SnowflakeDbException : 指定了不正确的用户名或密码。 堆栈跟踪: at Snowflake.Data.Client.SnowflakeDbConnection.Open() in D:\LululemonResources\VS\snowflake-connector-net-master\snowflake-connector-net-master\Snowflake.Data\Client\SnowflakeDbConnection.cs:line 113 at Snowflake.Data.Tests.SFDbCommandIT.TestCancelQuery() in D:\LululemonResources\VS\snowflake-connector-net-master\snowflake-connector-net-master\Snowflake.Data.Tests\SFDbCommandIT.cs:line 207 失败的测试数据源错误 错误信息: Snowflake.Data.Client.SnowflakeDbException : 指定了不正确的用户名或密码。 堆栈跟踪: at Snowflake.Data.Client.SnowflakeDbConne
请确保检查连接字符串中的"帐户"和"主机"值。 文档在这里: https://github.com/snowflakedb/snowflake-connector-net/blob/master/README.md
您需要确保将整个主机网址放入 rigion(例如澳大利亚东部),而不仅仅是 account.snowflakecomputing.com。 例如主机 = XXX.australia-east.snowflakecomputing.com
以下 github 存储库可能会为您节省大量时间。 它是用于 Azure 数据工厂的 .NET 框架,利用 Azure 函数来执行。 在 Microsoft 拥有 ADF 的认证源和水槽之前,几个 Snowflake 客户正在利用这一点。 https://github.com/jeremiahhansen/snowflake-connector-adf