Yes that's correct, see here: https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-errors-and-possible-solutions?view=sql-server-ver16

It mentions: This error is likely due to changing the PolyBase service account. To change the service accounts for the PolyBase Engine and...

I found your same error message here: https://rafaeldontalgoncalez.com/2018/10/sql-server-2019-polybase-mongodb

Give me the results of this query: SELECT * FROM [DWDiagnostics].[dbo].[pdw_errors]

I googled a little bit and it could be the account doesn't have permissions, you need to dig further into the logs. Also, take a look here: https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-errors-and-possible-solutions?view=sql-server-ver16

According to this: https://www.cdata.com/kb/tech/access-odbc-polybase.rst

You would put the DSN in the connection options:

CREATE EXTERNAL DATA SOURCE cdata_access_source
WITH (
LOCATION = 'odbc://SERVER_URL',
CONNECTION_OPTIONS = 'DSN=CData Access Sys',
-- PUSHDOWN =...

In the external data source you don't specify the database name. It is in the external table that you specify the database name, for example:

-- SQL Server
CREATE...

Big Data Cluster is similar to SQL Server on Linux with Polybase, so you can only connect to Hadoop, Oracle, Teradata and Cosmos, you can't connect to other ODBCs.

It is also important to note there is a 32-bit and 64-bit installer, you can use either of them. If it is the 64-bit version, the connection options must be...

In the book "Hands-On Data Virtualization with Polybase" you learn how to install SQL Server on Windows Server Core running on Docker Windows, so you don't rely on Microsoft.

In the book "Hands-On Data Virtualization with Polybase" you learn how to install SQL Server on Windows Server Core running on Docker Windows, so you don't rely on Microsoft.

Hi eliassal, you can easily modify the script to substract 45 days from the X value, then you will get what you want. Just remember the value of in...

Hi eliassal, yes the code looks good, so you have the database name, the starting point (day 0, 45 days ago, with size 47 for StackOverflow2013), and the final point...

Hi eliasal, in that case you can rewrite the query as follows:

SELECT [Name], 0, b
  FROM [lr] GROUP BY [Name], [m], b
 UNION ALL
SELECT [Name], 90,...

• This reply was modified 3 years, 7 months ago by  Pablo Echeverria.

Hi eliassal, this is calculated in the CTEs named [slope] (calculates m) and [lr] (linear regression), then you can see in the next statement it is grouped by [m] and...

Hi eliassal, can you please clarify your request?

I miss seeing more articles daily, but it's understandable the fatigue you're facing, I would like to see more people supporting this project to give you a rest.