หมวดหมู่: Data Transformation

WITH RawData (tag_name) AS (
    SELECT DISTINCT TRIM(unnest(string_to_array(
        'Access,Admin,Algorithm,Application,Authentication,Backup,Broken,Brute,Code,Components,Control,Cryptographic,Data,Database,Default,Design,Digital,Error,Failures,Firewall,Force,Forgery,Framework,HTTP,HTTPS,ID,Identification,Injection,Insecure,Integrity,Library,Log,Logging,Login,Misconfiguration,Module,Monitoring,Open,Outdated,OWASP,password,Patch,Plaintext,Project,Request,Security,Server-Side,Session,Signature,Software',
        ','
    )))
)
SELECT * FROM RawData;

WITH RawData (tag_name) AS (
    SELECT DISTINCT TRIM(value)
    FROM STRING_SPLIT(
        'Access,Admin,Algorithm,Application,Authentication,Backup,Broken,Brute,Code,Components,Control,Cryptographic,Data,Database,Default,Design,Digital,Error,Failures,Firewall,Force,Forgery,Framework,HTTP,HTTPS,ID,Identification,Injection,Insecure,Integrity,Library,Log,Logging,Login,Misconfiguration,Module,Monitoring,Open,Outdated,OWASP,password,Patch,Plaintext,Project,Request,Security,Server-Side,Session,Signature,Software',
        ','
    )
)
SELECT * FROM RawData;

WITH RawData AS (
    SELECT DISTINCT TRIM(tag) AS tag_name
    FROM UNNEST(SPLIT(
        'Access,Admin,Algorithm,Application,Authentication,Backup,Broken,Brute,Code,Components,Control,Cryptographic,Data,Database,Default,Design,Digital,Error,Failures,Firewall,Force,Forgery,Framework,HTTP,HTTPS,ID,Identification,Injection,Insecure,Integrity,Library,Log,Logging,Login,Misconfiguration,Module,Monitoring,Open,Outdated,OWASP,password,Patch,Plaintext,Project,Request,Security,Server-Side,Session,Signature,Software',
        ','
    )) AS tag
)
SELECT * FROM RawData;

WITH RawData AS (
    SELECT DISTINCT TRIM(f.value::STRING) AS tag_name
    FROM TABLE(FLATTEN(input => SPLIT(
        'Access,Admin,Algorithm,Application,Authentication,Backup,Broken,Brute,Code,Components,Control,Cryptographic,Data,Database,Default,Design,Digital,Error,Failures,Firewall,Force,Forgery,Framework,HTTP,HTTPS,ID,Identification,Injection,Insecure,Integrity,Library,Log,Logging,Login,Misconfiguration,Module,Monitoring,Open,Outdated,OWASP,password,Patch,Plaintext,Project,Request,Security,Server-Side,Session,Signature,Software',
        ','
    ))) AS f
)
SELECT * FROM RawData;

WITH RawData AS (
    SELECT DISTINCT TRIM(j.tag) AS tag_name
    FROM JSON_TABLE(
        CONCAT('["', REPLACE('Access,Admin,Algorithm,Application,Authentication,Backup,Broken,Brute,Code,Components,Control,Cryptographic,Data,Database,Default,Design,Digital,Error,Failures,Firewall,Force,Forgery,Framework,HTTP,HTTPS,ID,Identification,Injection,Insecure,Integrity,Library,Log,Logging,Login,Misconfiguration,Module,Monitoring,Open,Outdated,OWASP,password,Patch,Plaintext,Project,Request,Security,Server-Side,Session,Signature,Software', ',', '","'), '"]'),
        '$[*]' COLUMNS (tag VARCHAR(100) PATH '$')
    ) AS j
)
SELECT * FROM RawData;