Skip to content

Data Profile: dd07t

Generated: 2025-11-24 19:47:54.037635 Schema: raw.dd07t Total Rows: 1,089,277 Columns: 9 Completeness: 99.22%

Source Files

File Rows Size
20251105002001_dd07t_6120.csv 1,089,277 156.2 MB
Total 1,089,277 156.2 MB

Column Summary

# Column Type PostgreSQL Nullable Nulls Unique
1 DOMNAME string VARCHAR(45) No 0.00% 0
2 DDLANGUAGE string VARCHAR(1) No 0.00% 0
3 AS4LOCAL string VARCHAR(1) No 0.00% 0
4 VALPOS string VARCHAR(6) No 0.00% 0
5 AS4VERS string VARCHAR(6) No 0.00% 0
6 DDTEXT string VARCHAR(93) No 0.00% 0
7 DOMVAL_LD string VARCHAR(15) No 0.00% 0
8 DOMVAL_HD string VARCHAR(15) No 0.00% 0
9 DOMVALUE_L string VARCHAR(15) Yes 7.01% 0

Detailed Column Profiles

1. DOMNAME

Type: string → VARCHAR(45)
Nullable: No

Metric Value
Total Rows 1,089,277
Non-null 1,089,277 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 30
Avg Length 0.0
Buffered Length 45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,089,277 - Parse Success: 1,089,277 / 1,089,277

Sample Values: 

/SEEAG/DS_WF_FIELDNAME_POS_FRG, QATTRIBUT                     , INCO_AUGRD_KK                 , IUUC_IDENT_TYPE               , J_1BLB09NO

2. DDLANGUAGE

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 1,089,277
Non-null 1,089,277 (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: 1,089,277 - Parse Success: 1,089,277 / 1,089,277

Sample Values: 

E, D, F, I, S

3. AS4LOCAL

Type: string → VARCHAR(1)
Nullable: No

Metric Value
Total Rows 1,089,277
Non-null 1,089,277 (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: 1,089,277 - Parse Success: 1,089,277 / 1,089,277

Sample Values: 

A, N

4. VALPOS

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 1,089,277
Non-null 1,089,277 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,089,277 - Parse Success: 1,089,277 / 1,089,277

Sample Values: 

0001, 0002, 0003, 0004, 0005

5. AS4VERS

Type: string → VARCHAR(6)
Nullable: No

Metric Value
Total Rows 1,089,277
Non-null 1,089,277 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 4
Avg Length 0.0
Buffered Length 6 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,089,277 - Parse Success: 1,089,277 / 1,089,277

Sample Values: 

0000

6. DDTEXT

Type: string → VARCHAR(93)
Nullable: No

Metric Value
Total Rows 1,089,277
Non-null 1,089,277 (100.0%)
Unique 0 (0.0%)
Min Length 0
Max Length 62
Avg Length 0.0
Buffered Length 93 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 1,089,277 - Parse Success: 1,089,277 / 1,089,277

Sample Values: 

                                                            , Dezember                                                    , Wochen                                                      , Horizontale Fusion                                          , Abhängigkeitsgruppe 16

7. DOMVAL_LD

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,089,277
Non-null 1,089,277 (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: 1,089,277 - Parse Success: 1,089,277 / 1,089,277

Sample Values:

8. DOMVAL_HD

Type: string → VARCHAR(15)
Nullable: No

Metric Value
Total Rows 1,089,277
Non-null 1,089,277 (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: 1,089,277 - Parse Success: 1,089,277 / 1,089,277

Sample Values:

9. DOMVALUE_L

Type: string → VARCHAR(15)
Nullable: Yes

Metric Value
Total Rows 1,089,277
Non-null 1,012,955 (93.0%)
Null 76,322 (7.01%)
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: 1,089,277 - Parse Success: 1,089,277 / 1,089,277

Sample Values: 

1, 2, 3, X, 4

PostgreSQL DDL

See dd07t_schema.sql

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