mitsos
New Contributor
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: How to read a value from a CSV and pass it (edited) further down to be the name of my Azure SQL db
This works! Thank you!!! It is a bit slow, but think it will be fine. There are about 100k rows in each pipeline. So, _tableName → the underscore means what, exactly? It has to be a pipeline parameter, right? How does the Execute Pipeline snap “know” to take only one value from the $tableName column?2.4KViews0likes1CommentRe: How to read a value from a CSV and pass it (edited) further down to be the name of my Azure SQL db
@dimitri.hristovski thank you so much for taking the time - I think the clue that I needed was in the Mapper snap. I think I have figured it out, but I need to check a couple more things tomorrow.2.4KViews0likes0CommentsHow to read a value from a CSV and pass it (edited) further down to be the name of my Azure SQL db
Greetings, I have a pipeline that reads a Splunk report, converts to CSV and uploads to Azure SQL. One of the columns of my CSV is called _time. All the values of _time are from the same day: 2020-06-01T13:23:22.321 -04:00 where the first ten characters (i.e. “2020-06-01” are identical in the whole column. So, I would like to grab the first value and take the first ten characters to use them down the pipe for my Azure SQL db name (i.e. dbo.temp_dailies_2020-06-01). Can you suggest a way to do so? Sample of my CSV: I have done some progress using the Unique snap… Am trying to figure out how to bring it to my main pipeline… Main pipeline: Here I get the unique “2010-06-01” Basically I kinda need to merge the two… I think… Or any other suggestions are welcome Thank you, Mitsos4.1KViews0likes5CommentsError connecting to Azure SQL
Greetings, We are trying to connect to an Azure SQL database and we are getting the following errror… The port is 1433 because we checked in our DB properties… Screenshot_2020-05-20 17.52.42_ITXy5I|690x83 We have tried many different things so I am trying to see if there are any “gotchas” you may have to share Thank you Mitsos2.7KViews0likes2Comments