Why are CSV/JSON files not discovered in a Dataplex curated zone?
You are managing a Dataplex environment with raw and curated zones. A data engineering team is uploading JSON and CSV files to a bucket asset in the curated zone but the files are not being automatically discovered by Dataplex. What should you do to ensure that the files are discovered by Dataplex?
Community Votes
66% of anonymous learners picked answer A. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
The question tests whether you know the supported file formats for Dataplex curated zones; the common trap is assuming auto-discovery is the fix when the real issue is that CSV/JSON files are not valid for curated zones.
In Google Cloud Dataplex, curated zones support only specific analytics-optimized formats like Parquet, Avro, ORC, and BigQuery tables. Community consensus indicates that moving CSV/JSON files to a raw zone is the correct action, since enabling auto-discovery alone cannot catalog unsupported formats in a curated zone.
Option B (Enable auto-discovery of files for the curated zone) is the most common wrong answer. Auto-discovery cannot make Dataplex catalog formats that curated zones are not designed to support; the root cause is the zone's format restriction, not a discovery setting.
Community Discussion (19 comments)
- Auto-Discovery Feature: Dataplex has an auto-discovery feature that, when enabled, automatically discovers and catalogs data assets within a zone. - Appropriate for Both Raw and Curated Zones: This feature is applicable to both raw and curated zones, and it should be tailored to the specific data governance and cataloging needs of the organization.
- Raw zones store structured data, semi-structured data such as CSV files and JSON files, and unstructured data in any format from external sources. Raw zones are useful for staging raw data before performing any transformations. Data can be stored in Cloud Storage buckets or BigQuery datasets. - Curated Zones do not support JSON / CSV
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
Dataplex curated zones are intended for data that has been transformed and organized for analytics. According to official documentation, curated zones support only Parquet, Avro, ORC, and BigQuery tables. CSV and JSON are semi-structured formats that are not in this allowed list. Therefore, when CSV/JSON files are placed in a curated zone, Dataplex cannot automatically discover and catalog them. Moving the files to a raw zone, which supports any file format including CSV and JSON, is the correct way to ensure discovery. This aligns with the highest-voted community answer and the official reference cited in the comments.Why the Other Options Are Wrong
Option B is incorrect because enabling auto-discovery does not relax the curated zone format restrictions; Dataplex will still not catalog unsupported formats. Option C is wrong because using the bq command-line tool loads data into BigQuery tables, which does not address automatic file discovery in the bucket asset. Option D is wrong because granting object-level access controls permissions, not discovery; the files are not discovered due to format incompatibility, not authorization.Community Comment Notes
The community is split, with 66% favoring option A and 34% favoring option B. Comment 1 correctly points out that curated zones require Parquet, Avro, or ORC format, referencing the official docs. Comment 6 reinforces this by citing the same limitation. Comment 7 argues for option B but misunderstands the core issue: enabling auto-discovery only affects scanning, not whether a file format is eligible for cataloging in a curated zone. Overall, the weighted usefulness of the comments favors the format-restriction explanation.Official Reference
Exam Strategy
When a Dataplex question mentions discovery failures, first check the file formats against the zone type. Remember: raw zones accept almost any format, while curated zones only accept Parquet, Avro, ORC, and BigQuery tables. If you see CSV or JSON in a curated zone, the solution is to move the data to a raw zone, not to toggle discovery settings.