Home
> SQL Server 2016 > What is external tables for in SQL Server 2016 ? – MSDN TSQL forum
What is external tables for in SQL Server 2016 ? – MSDN TSQL forum
–> Question:
Running 2016 CTP3.
I would appreciate your personal comments/experience more than links.
–> Answer:
External Tables in SQL Server 2016 are to setup the new Polybase feature with SQL Server.
With this new feature (Polybase) you can connect to Azure blog storage or Hadoop to query non-relational data from SSMS and integrate with SQL Server relational tables.
You can check some details here, where I’ve : https://sqlwithmanoj.com/2015/05/29/installing-sql-server-2016-ctp2-and-new-features-in-ssms/
Check here how to setup Polybase: https://msdn.microsoft.com/en-IN/library/mt163689.aspx
Ref link.
Categories: SQL Server 2016
External Table, MSDN TSQL forum, SQL Server 2016
Leave a reply to joymon Cancel reply
Current Visitors
StatCounter …since April 2012
Leisure blog: Creek & Trails
- NMDC Hyderabad Marathon – My first 42k FM, cramps, training and fuelling
- Singapore (Part 2) – 6 days itinerary, sightseeing & attractions
- Singapore (Part 1) – Tickets, Visa, Hotel, Forex Card/Cash, Metro/Bus cards
- I got full refund of my flight tickets during COVID lockdown (AirIndia via MakeMyTrip)
- YouTube – Your Google Ads account was cancelled due to no spend
- YouTube latest update on its YPP (YouTube Partner Program) which may affect your channel
- Starting your own blog !!!
- How to file ITR (Income Tax Return) online AY 2017-18 (for simple salaried)
- Scam – Become a kin/hier and earn a fortune – via LinkedIn and Email
- Places to visit in and around Vizag (aka Visakhapatnam)
SQL with Manoj 
Does this external tables support primary key foreign key relations? Hope it cant as its not relation data. Any official documentation on what are the limits or differences with normal tables.