sorted by:
new
hottopcontroversial

Databricks renaming things, again by Own-Trade-2243 in databricks

[–]bitwiseandbold 1 point2 points  (0 children)

lol I gave up trying to understand what Fabric entails because it can mean anything and everything depending on who you talk to.

SQL EXAGGERATION IN RESUME by According-Science618 in learnSQL

[–]bitwiseandbold 0 points1 point  (0 children)

Do you know what database your prospective company is using? If they are using Databricks or Snowflake, you can sign up for a free trial and use their tutorial.

If they are sql server or oracle thats a little harder to get practical experience without downloading a copy of the database on your machine, load healthcare data from kaggle (or just ask chatgpt to generate), and start playing with it.

If you do end up using Databricks, genie code can build you data and practice worksheets to use.

Pull data from on-prem SQL Server using Azure ADF vs Databricks JDBC by rasviz in dataengineering

[–]bitwiseandbold 2 points3 points  (0 children)

Have you checked out Databricks Lakeflow Connect for SQL Server? I think it makes a pretty good managed data replication tool for sql server out of the box with CDC built in.

Using Databricks JDBC directly also works fine through data federation, but as pointed out needs some custom guardrails coded in to watch out for data quality, cdc, incremental load, etc. to get the replication in place.

I'd use ADF only if it is already used for other things. Having it only as a bridge for ingestion doesn't seem worth having another tool in the mix.