Trying to connect to sink table on SQL Server on my machine using the self-hosted IR but it says self-hosted IR is not supported in dataflow. can you please let us know how you connected to your on-premise SQL Server from Azure? Please provide the solution
Trying to connect to sink table on SQL Server on my machine using the self-hosted IR but it says self-hosted IR is not supported in dataflow. can you please let us know how you connected to your on-premise SQL Server from Azure?
In the Sink under mappings source column id would have mapped with EmpId column of sink. Mappings should available under third tab or fourth tab of sink I guess.kindly check tabs of sink you will find it
Thanks for the helpful video. What logic do I need to use in Alter Row if Row ( sink) exist but Row (source) doesn't exist then change the value of a field in Row (sink) ? Any help is much appreciated!
Hello I want to filter data in alter based on date condition. In source i have one date column. So based on that column i have to filter data. Like i want fetch only records which inserted or updated in last 7 days. How can write logic for this? Can you please tell me here?
Superb videos
It really understanding n easy to understand
Trying to connect to sink table on SQL Server on my machine using the self-hosted IR but it says self-hosted IR is not supported in dataflow. can you please let us know how you connected to your on-premise SQL Server from Azure? Please provide the solution
Great and easy explanation, but "Upsert" not covered, please make a video on that also. Thank you.
Can you please show which SQL framework you used to create DB/Table etc...and how you connected from azure to to the SQL?
Yes sir please
Hi, If I need to use all the columns as Key column dynamically from source dataset or last stream, how should I do that?
Trying to connect to sink table on SQL Server on my machine using the self-hosted IR but it says self-hosted IR is not supported in dataflow. can you please let us know how you connected to your on-premise SQL Server from Azure?
did you got the answer?
Maheer, can you please upload some real time scenarios to work in databricks using SQL, python and dataframes codings?
is Alter row transformation is a similar concept to Merge with update, delete, and insert
in MS SQL
Sir in the sink time u choose dataset with dbemployee what it indicate output file or what
Good explaination. Is there a way to do incremental loading using data flow?
@WafaStudies please make a video on incremental load, type 1 and type 2 SCD
Good video, will you clarify on how key column on sink (Eg.Emp ID)will map exactly source data column Emp ID, if they are in different name on update?
In the Sink under mappings source column id would have mapped with EmpId column of sink. Mappings should available under third tab or fourth tab of sink I guess.kindly check tabs of sink you will find it
Salesforce connector is not available in data flows. What could be the workaround for applying alter row transformation on Salesforce.
Thanks for the helpful video. What logic do I need to use in Alter Row if Row ( sink) exist but Row (source) doesn't exist then change the value of a field in Row (sink) ? Any help is much appreciated!
I realize I'm pretty randomly asking but do anybody know of a good website to watch newly released series online ?
@Fabian Malcolm i dunno I use Flixportal. just search on google after it :D -malachi
@Malachi Axl thank you, signed up and it seems like a nice service =) Appreciate it!!
Do you have an example of UpsertIf? Thanks in Advance
Can i use the same dataset for source and sink in mapping data flows?
Hello
I want to filter data in alter based on date condition. In source i have one date column. So based on that column i have to filter data. Like i want fetch only records which inserted or updated in last 7 days. How can write logic for this?
Can you please tell me here?
you said Alter Row TF works with database only but here you worked on .CSV file?
Bro. I need a help. I want to join two tables and I need to add a condition where I need to use max () function. How to achieve this?
Good content...i am trying this with table as source and table as destination. The conditions does not work...it inserts all the rows.
Before running it. Try data preview and see if u are getting output as expected.
@@WafaStudies the preview shows 100rows inserted, but it should be 1 row
@@vikasswain4434 u need to use delete if condition to exclude all other rows from getting inserted.
@@WafaStudies thanks for helping, I got it working now.
A request for making a video on upsert if in alter row transformation, on real life use case.
how do u create sampledb?
Kindly make sure to keep video within 10 mts
I am troubling while making dataset in this sql please help
Sure. Kindly share details on email or WhatsApp. Will try to help
@@WafaStudies thnks
Bro, I want to update the cells which are having NULL to '' . How is that possible? UPDATE TABLE_NAME SET COLUMN1='' where COLUMN1 IS NULL
You can use derived transformation to make it blanks for null values
plz add dataset aslo