Skip to main content
O
OSAdmin
May 5, 2021
Solved

Matrix load using a connector data surce

  • May 5, 2021
  • 2 replies
  • 0 views
Originally posted by Vignesh Mohan

Hi,

I am trying to import data from Snowflake using JDBC / ODBC connection. In the Snowflake side a view has been created with the correct data set for the import. The connectivity as such works as I tested the same through the Data Adapter in the Dashboards. I am able to retrieve data for the same query that I am using in the connector rule using this test method. The data structure type in the data source section in OneStream is setup as Matrix data as I need some of the column names to be mapped to the Accounts dimension members. When I run the data import from the workflow, I get the following error,

No valid DataKeys (Scenario / Time) found in data source.  Review the source data load processing log and check one-to-one transformation rules to ensure that you have created proper Scenario and Time dimension rules for this data source.

All dimensions are mapped appropriately in the transformation rules. I am also using few attributes to import the data and I have leveraged them in the transformation rule for composite mapping for few dimensions.

Thanks in advance.

Regards,

Vignesh

Best answer by OSAdmin
Originally posted by Vignesh Mohan

This issue is now fixed. The issue was because of the format of workflow year and period that was sent as parameter to the query that retrieves the data from the source. In our setup the periods are setup as 2019M1, however at source the period is 01. Just had to make some minor tweaks in the connector rule to get the formatting correct.

2 replies

O
OSAdminAuthorAnswer
May 12, 2021
Originally posted by Vignesh Mohan

This issue is now fixed. The issue was because of the format of workflow year and period that was sent as parameter to the query that retrieves the data from the source. In our setup the periods are setup as 2019M1, however at source the period is 01. Just had to make some minor tweaks in the connector rule to get the formatting correct.

T
TyeshaAdams
June 3, 2024

Hello, I am trying to connect to Snowflake using the Data Adapter but receiving the error message below.  Can you please share an example of the query you are using in the data adapter to retrieve the data from Snowflake?  Thanks!


TyeshaAdams_0-1717437408797.png

 

Terms & ConditionsAccessibility statement