Failure to build featureset

I have been trying to build my featureset for hours now, still getting this error.

layer run
Layer 0.7.3 using https://beta.layer.co
Loading the project under /Users/codebrain/Documents/Layer_projects/anomaly_detection
Found 1 dataset, 1 featureset and 0 models
πŸ“” Session logs at /Users/codebrain/.layer/logs/20210831T211203-session-1be78353-4df7-4d2a-97e5-900108ba14b3.log
πŸ’Ύ Starting...
πŸ”΅ Pipeline run id: efafeaa3-c03a-45ee-948a-e74849d03528
2021-08-31 21:12:06 | dataset     transactions                   ━━━━━━━━━━━━━━━━━━━━━━ DONE      [328ms]                                                   
2021-08-31 21:12:07 | featureset  transaction_features           ━━━━━━━━━━━━━━━━━━━━━━ ERROR     [7036ms]                                                  
                                 Unable to provision, see the following errors:                                                                            
                                                                                                                                                           
                                 1) Error in custom provider, java.lang.IllegalArgumentException: Invalid Table ID 'anomaly detection table'. Must match   
                                 '^(((\S+)[:.])?(\w+)\.)?([\S&&[^.:]]+)$$'                                                                                 
                                   at                                                                                                                      
                                 com.google.cloud.spark.bigquery.v2.SparkBigQueryConnectorModule.provideSparkBigQueryConfig(SparkBigQueryConnectorModule.… 
                                   while locating com.google.cloud.spark.bigquery.SparkBigQueryConfig                                                      
                                                                                                                                                           
                                 1 error                                                                                                                   
                                 Aborting...                                                                                                               
LAYER RUN FAILED after 8972ms:
Failed to build featureset 'transaction_features': Unable to provision, see the following errors:

1) Error in custom provider, java.lang.IllegalArgumentException: Invalid Table ID 'anomaly detection table'. Must match 
'^(((\S+)[:.])?(\w+)\.)?([\S&&[^.:]]+)$$'
 at com.google.cloud.spark.bigquery.v2.SparkBigQueryConnectorModule.provideSparkBigQueryConfig(SparkBigQueryConnectorModule.java:68)
 while locating com.google.cloud.spark.bigquery.SparkBigQueryConfig

1 error

Hey @CodeBrain, thank you for reaching out!

Based on the error, it may be that the dataset is configured for a table named β€œanomaly detection table” but the BigQuery connector is throwing a validation error saying the name should match the regex β€œ^(((\S+)[:.])?(\w+).)?([\S&&[^.:]]+)$$”. Can you try with a table name that doesn’t have spaces?

Can you also please share the source code for your project? We can help debug further based on that.

1 Like

Hey @CodeBrain, I will close this topic as it seems like it’s resolved. Please let us know if not!

1 Like