I know in the video you say I don’t need to worry about setting up CORS, but when I make calls to the API, there is no CORS header. When I added the configuration file and add CORS settings, there still is no CORS header.
@lostfrequency894 ай бұрын
What happens if I have managed table in databricks ?
@user-ks7ex9mp7i9 ай бұрын
I have a table with primary key as guid / unique identifier. { "LocationId": "string", // this is the primary key "LocationName": "string", "LocationAddress": "string" } Location id is the primary key. I want to exclude it during the post operation. how to do it.
@JerryNixon10 ай бұрын
Pretty cool stuff from a free engine like Data API builder
It was great meeting you at Build and learning about DAB. Going through the videos now and wondering when Part 3 is on its way?
@ralral2132 Жыл бұрын
Why is this session not available at MS Build anymore? The provided link is not working.....???
@kbaig6651 Жыл бұрын
how is this different then OData we use to have back in the days ?
@theazuresqldeveloper Жыл бұрын
Conceptually it is like OData, but it is more modern and easier for the user. GraphQL especially is becoming a de facto standard.
@thomasgauvin Жыл бұрын
Subbed!
@rory6528 Жыл бұрын
P r o m o s m
@powereng10002 жыл бұрын
Hi, Security Attestations will fail these development concepts with Prisma and a lot of NPM libraries.... That's why Microsoft corp doesn't even promote libraries on the Power Platform component framework.... GDPR will be up your asses if solutions are not compliant via ALM.
@bfarhan83 жыл бұрын
Where can i find the reference for the C-Sharp language?
@lucaargento95523 жыл бұрын
Hi davide, about your considerations, this solution could be good to sync database bidirectional from offline device to CLOUD (Azure SQL)? I mean, AZURE SQL DB and for example a XAMARIN App with SQLite database, to sync data from offline device to AZURE sql and viceversa. In this case i have to manage concurrency if a lot of offline devices sync theirs data to AZURE SQL. I have version and RecordedOn to check what update wins, but if customer change date on device? Maybe version and recordedOn date is not enough? Thanks in advantage
@theazuresqldeveloper3 жыл бұрын
Definitely yes. Change Tracking doesn't use date to keep track of changes, but version numbers, so even if the user change the date on the device, Change Tracking will be unaffected. Give it a try :)
@Tronald813 жыл бұрын
This is amazing. Thank you for sharing. I would love to know if there is anyone who has developed the missing part here to actually store it in a database. This appears to only be the server side code.
@theazuresqldeveloper3 жыл бұрын
Hi Ron. I guess you are referring to the version number when you say "store it in a database", right? If yes that would be no different than a simple CRUD operation to read and write from/to a table
@JoshKewley4 жыл бұрын
Github link is broken
@theazuresqldeveloper4 жыл бұрын
Thanks, fixed :)
@obloch4 жыл бұрын
Ciao Davide. Nice video. Shouldn't the title say IoT Hub instead of Event Hubs?
@theazuresqldeveloper4 жыл бұрын
Ciao Oliver! I'm showing Event Hubs in the demo, just 'cause it can be used for a broader number of ingestion use cases: I used IoT as one sample of ingestion and streaming at scale scenario. Of course if someone needs to do IoT specifically and need IoT specific features and protocols, IoT Hub is the way to go, and it can be used in place of Event Hubs without any major change to the architecture. Actually, let me a link to the "Connecting IoT Devices to Azure: IoT Hub and Event Hubs" here so that anyone who wants to understand the differences can get a boost: docs.microsoft.com/en-us/azure/iot-hub/iot-hub-compare-event-hubs
@ElisaPiccin4 жыл бұрын
Hi Davide and thanks for sharing this super-interesting scenario. Can you tell us a little bit more about the Azure SQL Database tier that you used for the 10k msg/second test case?
@theazuresqldeveloper4 жыл бұрын
Sure, it's the Tier specified in the source code: Hyperscale or Business Critical 16vCores: github.com/Azure-Samples/streaming-at-scale/blob/master/eventhubs-streamanalytics-azuresql/create-solution.sh#L84
@guillaumemichael9514 жыл бұрын
Really interesting video, what about synchronizing data that are dependent of others table and may have been updated?
@theazuresqldeveloper4 жыл бұрын
Thanks! To synchronize data that are dependent on other tables you just need to activate Change Tracking also on the dependent tables. Then you can decide if you want to return just one JSON for the whole change (including the dependent tables, this could be done with a JSON or a subquery) or if you prefer to return a JSON for each table.
@webgio272 жыл бұрын
@@theazuresqldeveloper I'm interested in this scenario but wouldn't we have two different version numbers? is it possible to merge them and have a single version number for two or multiple tables?
Пікірлер
I know in the video you say I don’t need to worry about setting up CORS, but when I make calls to the API, there is no CORS header. When I added the configuration file and add CORS settings, there still is no CORS header.
What happens if I have managed table in databricks ?
I have a table with primary key as guid / unique identifier. { "LocationId": "string", // this is the primary key "LocationName": "string", "LocationAddress": "string" } Location id is the primary key. I want to exclude it during the post operation. how to do it.
Pretty cool stuff from a free engine like Data API builder
🔥🔥🔥🔥
Register here: www.eventbrite.com/e/future-data-driven-summit-2023-tickets-618186220627
How / Where can In deploy this?
It was great meeting you at Build and learning about DAB. Going through the videos now and wondering when Part 3 is on its way?
Why is this session not available at MS Build anymore? The provided link is not working.....???
how is this different then OData we use to have back in the days ?
Conceptually it is like OData, but it is more modern and easier for the user. GraphQL especially is becoming a de facto standard.
Subbed!
P r o m o s m
Hi, Security Attestations will fail these development concepts with Prisma and a lot of NPM libraries.... That's why Microsoft corp doesn't even promote libraries on the Power Platform component framework.... GDPR will be up your asses if solutions are not compliant via ALM.
Where can i find the reference for the C-Sharp language?
Hi davide, about your considerations, this solution could be good to sync database bidirectional from offline device to CLOUD (Azure SQL)? I mean, AZURE SQL DB and for example a XAMARIN App with SQLite database, to sync data from offline device to AZURE sql and viceversa. In this case i have to manage concurrency if a lot of offline devices sync theirs data to AZURE SQL. I have version and RecordedOn to check what update wins, but if customer change date on device? Maybe version and recordedOn date is not enough? Thanks in advantage
Definitely yes. Change Tracking doesn't use date to keep track of changes, but version numbers, so even if the user change the date on the device, Change Tracking will be unaffected. Give it a try :)
This is amazing. Thank you for sharing. I would love to know if there is anyone who has developed the missing part here to actually store it in a database. This appears to only be the server side code.
Hi Ron. I guess you are referring to the version number when you say "store it in a database", right? If yes that would be no different than a simple CRUD operation to read and write from/to a table
Github link is broken
Thanks, fixed :)
Ciao Davide. Nice video. Shouldn't the title say IoT Hub instead of Event Hubs?
Ciao Oliver! I'm showing Event Hubs in the demo, just 'cause it can be used for a broader number of ingestion use cases: I used IoT as one sample of ingestion and streaming at scale scenario. Of course if someone needs to do IoT specifically and need IoT specific features and protocols, IoT Hub is the way to go, and it can be used in place of Event Hubs without any major change to the architecture. Actually, let me a link to the "Connecting IoT Devices to Azure: IoT Hub and Event Hubs" here so that anyone who wants to understand the differences can get a boost: docs.microsoft.com/en-us/azure/iot-hub/iot-hub-compare-event-hubs
Hi Davide and thanks for sharing this super-interesting scenario. Can you tell us a little bit more about the Azure SQL Database tier that you used for the 10k msg/second test case?
Sure, it's the Tier specified in the source code: Hyperscale or Business Critical 16vCores: github.com/Azure-Samples/streaming-at-scale/blob/master/eventhubs-streamanalytics-azuresql/create-solution.sh#L84
Really interesting video, what about synchronizing data that are dependent of others table and may have been updated?
Thanks! To synchronize data that are dependent on other tables you just need to activate Change Tracking also on the dependent tables. Then you can decide if you want to return just one JSON for the whole change (including the dependent tables, this could be done with a JSON or a subquery) or if you prefer to return a JSON for each table.
@@theazuresqldeveloper I'm interested in this scenario but wouldn't we have two different version numbers? is it possible to merge them and have a single version number for two or multiple tables?