RE: How do I deal with spaces in my source Splice Machine table column names?
My Splice Machine source table has multiple column names that include spaces (e.g. First Name, Last Name, etc.). How do I work around that in Diyotta? I have tried several things, but my data flow continues to fail when it encounters First Name.
In Diyotta we do handle the spaces and reserved keywords as column names in the Table, by enabling the option Strict Name = YES.
which is currently included in the MSSQL, will add an enhancement to include the same property for Splice Machine.
As a workaround, please follow the below steps
- Create a job flow, for the splice machine dataflow and click on dataflow transforms.
- Open the override command present for the target as my dataflow is having only the source and target present in it.
- Enclose the column where there are spaces in double quotes.
Then try to execute the job flow.