Blank data is getting inserted for primary key column in data schema | Community
Skip to main content
M
mustufam5967803
Level 3
April 11, 2023
Solved

Blank data is getting inserted for primary key column in data schema

  • April 11, 2023
  • 1 reply
  • 1074 views

Hi Team,
For custom data schema we have created email as our primary key.

While inserting the data with data loading activity we noticed that there are certain records with blank email address still they got inserted into the database schema.
May I know how come a column with primary key is taking empty values in data schema

Following is the screenshot of email as primary key 


Blank data insertion screenshot 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by akshaaga

@mustufam5967803 ,

There could be several reasons why this may occur:

  1. Schema Design: The schema design may allow for empty or null values in the primary key column. For example, the primary key column may not have been defined with a NOT NULL constraint, or it may have been designed to allow null values.
  2. Database Management System (DBMS) Settings: The settings of the specific DBMS being used may allow for empty or null values in the primary key column. For example, some DBMS allow for null values in primary key columns by default, or there may be a specific configuration or setting that allows for this behavior.
  3. Data Loading Process: The data loading process used to insert data into the table may not be enforcing the primary key constraint properly. For example, the data loading process may not be validating or checking for empty or null values in the primary key column before inserting the data into the table.

It is important to review the schema design, DBMS settings, and the data loading process to determine why empty values are being allowed in the primary key column.

1 reply

akshaaga
Adobe Employee
akshaagaAdobe EmployeeAccepted solution
Adobe Employee
April 11, 2023

@mustufam5967803 ,

There could be several reasons why this may occur:

  1. Schema Design: The schema design may allow for empty or null values in the primary key column. For example, the primary key column may not have been defined with a NOT NULL constraint, or it may have been designed to allow null values.
  2. Database Management System (DBMS) Settings: The settings of the specific DBMS being used may allow for empty or null values in the primary key column. For example, some DBMS allow for null values in primary key columns by default, or there may be a specific configuration or setting that allows for this behavior.
  3. Data Loading Process: The data loading process used to insert data into the table may not be enforcing the primary key constraint properly. For example, the data loading process may not be validating or checking for empty or null values in the primary key column before inserting the data into the table.

It is important to review the schema design, DBMS settings, and the data loading process to determine why empty values are being allowed in the primary key column.

    Terms & ConditionsAccessibility statement

    Loading footer...