Skip to content

[FEATURE]: Detect usages of DBFS Mount paths in SQL code #1105

@nfx

Description

@nfx

Is there an existing issue for this?

  • I have searched the existing issues

Problem statement

SELECT * FROM parquet.`dbfs:/...` LIMIT 10
SELECT * FROM delta.`/mnt/...` WHERE foo > 6
DELETE FROM json.`/...` WHERE foo = 'bar'
MERGE INTO delta.`/dbfs/...` t USING source ON t.key = source.key WHEN MATCHED THEN DELETE

https://docs.databricks.com/en/sql/language-manual/delta-merge-into.html

Proposed Solution

Solution has to be in https://github.com/databrickslabs/ucx/blob/main/src/databricks/labs/ucx/source_code/queries.py

Additional Context

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    migrate/codeAbstract Syntax Trees and other dark magic

    Type

    No type

    Projects

    Status

    No status

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions