Data Profile: ettat¶

Generated: 2025-11-24 20:00:51.746406 Schema: raw.ettat Total Rows: 467 Columns: 4 Completeness: 100.00%

Source Files¶

File	Rows	Size
20251105002212_ettat_6120.csv	467	0.0 MB
Total	467	0.0 MB

Column Summary¶

#	Column	Type	PostgreSQL	Nullable	Nulls
1	MANDT	integer	INTEGER	No	0.00%
2	SPRAS	string	VARCHAR(1)	No	0.00%
3	TARIFTYP	string	VARCHAR(15)	No	0.00%
4	TTYPBEZ	string	VARCHAR(60)	No	0.00%

Detailed Column Profiles¶

1. MANDT¶

Type: integer → INTEGER
Nullable: No

Metric	Value
Total Rows	467
Non-null	467 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	20
Avg Length	0.0
Buffered Length	30 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 467 - Parse Success: 467 / 467

Sample Values:

2. SPRAS¶

Type: string → VARCHAR(1)
Nullable: No

Metric	Value
Total Rows	467
Non-null	467 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	1
Avg Length	0.0
Buffered Length	1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 467 - Parse Success: 467 / 467

Sample Values:

D, F, E

3. TARIFTYP¶

Type: string → VARCHAR(15)
Nullable: No

Metric	Value
Total Rows	467
Non-null	467 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	10
Avg Length	0.0
Buffered Length	15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 467 - Parse Success: 467 / 467

Sample Values:

EV3A.NHE  , EW.B00    , EWD.B00   , EWD.B35   , EWP.BXX

4. TTYPBEZ¶

Type: string → VARCHAR(60)
Nullable: No

Metric	Value
Total Rows	467
Non-null	467 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	40
Avg Length	0.0
Buffered Length	60 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 467 - Parse Success: 467 / 467

Sample Values:

Wiederverkäufer Netznutzungsentgelt E360, Gaz naturel avec CO2 100% compensé Chale, Gaz naturel Rétribution pour l’utilisati, Revendeur Rétribution pour l’utilisation, Contrat spécial interruptible Facturatio

PostgreSQL DDL¶

See ettat_schema.sql

Generated by process-csv-to-postgres v1.0.0