Skip to main content

Posts

Showing posts from 2024

PowerBI Get Tables enabled in a PowerBi Report

 1) Unpack the pbix file (ie: unzip it)  2) Find the DiagramLayout.json file 3) The table name will be in a node called  nodeIndex                 {                     "location" : {                         "x" : 588 ,                         "y" : 0                     },                     "nodeIndex" : "CALENDAR" ,                     "size" : {                         "height" : 206 ,                         "width" : 254                     },                     "zIndex" : 0                 }

CLONE a table in Snowflake

  Clone a Table in Snowflake  So simple,  CREATE TABLE TableName_Clone CLONE OriginalTableName To restore a table at a specific timestamp  CREATE TABLE  TableName_Clone   CLONE  OriginalTableName AT  (TIMESTAMP => TO_TIMESTAMP_TZ('11/04/2024 00:00:00', 'dd/mm/yyyy hh24:mi:ss'));

IEC 60320 Power Cords

  Mains Interconnect Diagram Pin spacing, centres (mm) Earth contact Appliance class Rewirable connector allowed? Max. current (A) Max. pin temp. (°C) Polarized Remarks and example uses Connector (Female) Appliance inlet (Male) Plug connector (Male) Appliance outlet (Female) C1 C2 - - 6.6 No II No 0.2 70 No C3 C4 - - 10 No II 2.5 70 Yes C5 C6 A B 10 (H) 4.5 (V) Yes I No 2.5 70 Yes Commonly referred to as a "clover-leaf" or "Mickey Mouse" connector  C7 C8 C D 8.6 No II No 2.5 70 No There is a similar polarized connector,  but this is not part of the standard. C9 C10 - - 10 No II No 6 70 No This kind of coupler is used by  Roland Corporation  and  Revox   for synthesizer and drum-computer models and  hi-fi equipment.  Was also by  Marantz C11 C12 - - 10 No II 10 70 Yes Similar to C9 with a slot in the connector, withdrawn from standard. C13 C14 E F 14 (H) 4 (V) Yes I Yes 10 70 Yes C15 C16 M N 14 (H) 4 (V) Yes I Yes 10 120 Yes For use in high-temperature settings (for