Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Learn Azure Synapse Data Explorer
  • Table Of Contents Toc
Learn Azure Synapse Data Explorer

Learn Azure Synapse Data Explorer

By : Pericles Rocha
5 (12)
close
close
Learn Azure Synapse Data Explorer

Learn Azure Synapse Data Explorer

5 (12)
By: Pericles Rocha

Overview of this book

Large volumes of data are generated daily from applications, websites, IoT devices, and other free-text, semi-structured data sources. Azure Synapse Data Explorer helps you collect, store, and analyze such data, and work with other analytical engines, such as Apache Spark, to develop advanced data science projects and maximize the value you extract from data. This book offers a comprehensive view of Azure Synapse Data Explorer, exploring not only the core scenarios of Data Explorer but also how it integrates within Azure Synapse. From data ingestion to data visualization and advanced analytics, you’ll learn to take an end-to-end approach to maximize the value of unstructured data and drive powerful insights using data science capabilities. With real-world usage scenarios, you’ll discover how to identify key projects where Azure Synapse Data Explorer can help you achieve your business goals. Throughout the chapters, you'll also find out how to manage big data as part of a software as a service (SaaS) platform, as well as tune, secure, and serve data to end users. By the end of this book, you’ll have mastered the big data life cycle and you'll be able to implement advanced analytical scenarios from raw telemetry and log data.
Table of Contents (19 chapters)
close
close
1
Part 1 Introduction to Azure Synapse Data Explorer
6
Part 2 Working with Data
12
Part 3 Managing Azure Synapse Data Explorer

Configuring continuous data export

All three data export mechanisms that we have explored so far with server-side data push are quite similar in syntax and in how they operate. They require someone to start the actual data export task, monitor it, and implement the logic to copy new data in the future. There is, however, one important advantage of exporting data to external tables: the possibility to use continuous data export to keep your external table updated as new records are inserted in the original table.

We’ll continue to build on the table created in the Exporting to external tables section. We did the initial data load and now we would like to set up a process that updates the content of the external table with new records inserted in the fleet data table every two hours. Continuous data export allows you to configure this process, ensuring that each record in your table is processed exactly once.

Here’s the syntax to create a new continuous data export...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Learn Azure Synapse Data Explorer
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon